Question Bank

PC SOFTWARE
FILL IN THE BLANKS

1. The Word Count option is in ------ menu (Tools)
2. The shortcut for slide show is ----------- (F5)
3. Search is in --------------------- (Start menu)
4. The Shortcut key for print is ---------------- (Ctrl + P)
5. A collection of worksheet is called --------- (Work book)
6. Merge cell is in ------------------------ menu (Table)
7. The Extension of a PowerPoint show is ----------- (.PPT)
8. Predefined Shapes are called ----- (Auto Shapes)
9. Setting can be done through -------------- (control Panel)
10. Insertion of a clip art depends on --------- ( slide notes)
11. For e – mailing a work sheet select ------- from file menu (send to)
12. For spell check use the key ------------- (F7)
13. Auto correct is in --------------- menu (Tools)
14. using ---------- we can change the color of the text (Font color)
15. Undo button is on ----------- tool bar (Standard)
16. the extension of a workbook is ------------------ (.Xls)
17. --------------unit performs the mathematical calculations (ALU)
18. ----------- we can be inserted in an excel sheet for pictures (Bitmap)
19. The maximum zoom percentage in Microsoft Power Point is ----------- (500)
20. Mouse is a ------------------ device (Input)
21. In windows, deleted files are present in ---------------- (Recycle bin)
22. Change case option is in ----------- menu of MS Word (format)
23. In Windows short cut key for cut option is --------------------- (Ctrl + X)
24. In MS Excel ------------- icon on the toolbar is used to find sum of numbers of selected cells automatically (Auto sum)
25. In Windows ---------------- function key is used to get help (F1)
26. To delete a worksheet document select --------- from the file menu (delete)
27. In MS Word Drop cap is in ---------------- menu (format)
28. The extension of excel file is ------------------ (.Xls)
29. In MS Excel ----------- function returns the number of entries in the selected range of cells ( count)
30. The extension of word file is ------------------- (.Doc)
31. The shortcut for italics is ---------------------------- (Ctrl + I)
32. In windows ---------------- icon displays all the computers in the network (Network neighborhood)
33. ------------------- is the storage area for items that have been cut or copied. (Recyle bin)
34. ---------------- is the shortcut key for paste operation (Ctrl + V)
35. In Word style option is in --------- menu (format)
36. In MS Word -------------- view shows the documents as it will look when it is printed (Print layout)
37. Macro option is in ---------------- menu (tools)
38. In windows--------------- function key is used to invoke help utility (F1)
39. In MS Word change case option is in -------------------- menu (format)
40. In Excel ------ is defined as the space where a specified row and column is intersect
( cell)
41. In Excel -------------- function returns smallest value in a selected range of cells (min)
42. -------------------- option is used to undo the previous key action (undo)
43. --------------- option used to save the document with a new file (save as)
44. --------------- enables you to move up and down in a document ( scrollbar)
45. ----------- feature helps to you to avoid typing mistake and helps you to speed up your typing (Auto correct)
46. Page break is in ------------- menu (insert)
47. Short cut key for slide show is -------------- (F5)
48. --------------------- feature in MS Word saves the document automatically (Auto save)
49. The picture option in Word is in ------------------- menu (insert)
50. In Excel using --------------- we can find the sum of a group of numbers (Auto sum)
51. In excel the numbers are usually --------------- aligned ( right)
52. The number of columns in a work sheet is -------------------------- (256)
53. Extension file of MS Access is --------- (.mdb)
54. An individual page in a Power Point presentation is called -------- (Slide)
55. A-------- is used to set the page margins, change paragraph alignment and spacing (Indent)
56. -------- is an example for Data base Management system (MS Access)
57. -------- displays the location of the active cell and the value or formula used in the active cell (fx)
58. -------- function will return the largest value in the selected range of cells (MAX)
59. A set of programming statements is called ------ (Macro)
60. Go to option is in --------- menu (Edit)

TRUE OR FALSE

1. In windows Desktop contains Recycle bin - T
2. Setting control done through control panel - T
3. Pie chart is an excel chart - T
4. If helps to create formulas and functions - T
5. Alignment is an example of formatting - T
6. A set of programming statement is called macro - T
7. Layout is a type of view - T
8. There should not be space between numbers in a formula - T
9. It is possible to create a database through Excel- F
10. It is not possible to delete an entire column from an Excel Sheet- T
11. It is possible to insert a work sheet into an Excel work book - T
12. It is not possible to change the name of a work sheet- F
13. It is possible to merge documents in a word application-
14. Mail Merge is an option in Word- T
15. It is possible to create presentations using templates - T
16. It is not possible to insert a blank slide to a presentation - F
17. Word Art can be inserted in an Excel sheet - T
18. Enter key should be pressed to start a new paragraph in MS Word. - T
19. DOS can be accessed from Windows - T
20. Pictures cannot insert in MS Excel sheets- F
21. Copy option is located in file menu - F
22. Currency is a data type available in MS Access - T
23. In windows folders cannot be renamed - F
24. Arithmetic calculations can be done using MS Excel - T
25. In DOS commands are case sensitive - T
26. We cannot print Malayalam documents using MS Word - F
27. Spell check is possible in Excel - F
28. Justify is an alignment type available in MS Word - T
29. The height and width of cell in Excel cannot be changed - F
30. JPEG is an image format - T
31. Excel is an example for spread sheet program - T
32. Ctrl + U is the short cut key for underline - T
33. Word is an office package - T
34. Through word it is possible to create tables - T
35. Word documents cannot be renamed - F
36. Screen server can be protected using a password - T
37. MS Excel cannot do calculations - F
38. MS Excel can produce graphs - T
39. .bmp is a picture format - T
40. Sorting of data is possible in Excel - T
41. Password protection is available in MS Word - T
42. The extension of PowerPoint file is .PPT - T
43. Sound can be embedded in a PowerPoint presentation - T
44. Password protection is available in MS Word - T
45. Page setup option is in Edit menu. - F
46. Power Point slide cannot be printed - F
47. In MS Access every table must have a primary key - F
48. Auto sum is a feature of MS Excel - T
49. Word Art can be inserted in a Excel sheet
50. It is possible to control sound in PowerPoint - T
51. It is possible to animate objects in a Web site- T
52. We can have different views in a Word document - T
53. We cannot set password to an Access file - F
54. Through Excel it is not possible to draw a line chart- F
55. It is possible to format a particular statement in Notepad – F
56. In Power point every slide contains text place holder (True)
57. Word documents cannot be saved on floppies (False)
58. Chart option is in Insert menu (True)
59. Protect document option is in tools menu (True)
60. Book mark is in Insert menu (True)

SHORT QUESTIONS

1. What is Macro
2. How you can insert a Chart in Excel
3. Explain the use of If
4. What you mean by Auto format
5. What are the features of PowerPoint
6. What are Header and Footer
7. What are the options in Table menu
8. Explain the difference between Save and Save as
9. Explain how you can draw a bar chart in Excel sheet
10. Describe how you can animate a slide in PowerPoint
11. What is the use of formula in Excel
12. discuss the difference between PPT
13. What you mean by comments in Excel
14. DOS can be accessed from Windows
15. How we can embed sound on PowerPoint presentation
16. Explain any 4 file menu commands available in MS Word
17. Explain different data types available in MS Access
18. What is Auto content Wizard
19. Explain the steps for creating Header and Footer in MS Word
20. How we can animate text in MS Word
21. What is macro? How we can create macro
22. Explain IF functions available in Excel
23. Difference between move and copy command
24. How can you print a page in Power Point
25. What you mean by spelling and Grammar check
26. What are the different options to create a table in Access
27. What is Work sheet and Work book
28. Explain the use of sort in a word document
29. How we can create reports in an access file
30. What is alignment? What are its different options
31. Explain the steps for animating a slide using custom animation
32. Explain the use of Treasures
33. Explain data validation
34. Difference between Paste and Paste special
35. Explain Print Dialogue box
36. What do you mean by Templates
37. Describe Paragraph settings in Page maker
38. How you can protect word document with password
39. Explain How to setup a Page
40. How to format a heading
41. Explain How to Create Table in Word
42. How to insert more than one Header and Footer
43. How to set Heading levels and outline numbers
44. How to Create Master document
45. How to mark Index entries
46. How to setup Tab stops
47. How to insert a cross reference
48. How to insert pictures
49. How to set our current symbol in Excel
50. How to set boarders for your statements
51. How to using formulas to paste link
52. How to create append query
53. How to create sub forms
54. What is status bar in Excel
55. How will you prepare a list in MS Access Table
56. What is the different between MS Query and Action Query
57. How will you bind a text with a rectangle box
58. Explain If analysis with example
59. Explain Data Analysis
60. Explain file allocation Table

ESSAY QUESTIONS:

1. Explain what is mail merge and how you can Mail Merge a document
2. What are the major features of Windows and Excel
3. Explain important features of excel
4. Explain the features of Microsoft Windows
5. Explain different formatting options available in MS Word
6. Explain the Major features of different MS Office software tools
7. Discuss the steps for creating a presentation in MS PowerPoint
8. What are functions in calculations? Explain with examples
9. What is the use of Word Processor? Explain any 4 menus of a Word Processor
10. How to insert different tools in Access
11. How to create Flow charts in Power Point
12. Explain conditional structures in PowerPoint
13. Explain How to animate a text
14. Explain about the different data types in Access
15. What are the main components of MS Access
16. Name the modules in office 200 and explain it briefly
17. What are the main features which made windows so popular
18. What are the different types of Graph? Write down steps to create a graph
19. Briefly explain about Desktop and Start Menu
20. Explain the techniques for making a PowerPoint show livelier
21. Discuss the steps for creating a presentation in MS PowerPoint
22. Explain the major features of different MS Office software tools
23. What is Query? What are the different types of Queries available in MS Access
24. Distinguish between style and macro
25. What is filtering? How can it be done? Write the steps
26. Explain different formatting options available in MS Word
27. What do you mean by Macro? What are its uses
28. What are functions? What is the significance of functions in calculations? Explain with examples.
29. Explain the different commands available in File menu of Word
30. Explain different options in View menu of Word